/*==============================================================*/
/* Table: TCompany                                              */
/*==============================================================*/
create table TCompany
(
Corp_ID          char(10)      NOT NULL,
Corp_Name        varchar(90)   NOT NULL,
Corp_Addr        varchar(90)   NOT NULL,
Corp_Contact     varchar(20)   ,
Corp_Tel         varchar(20)   ,
Corp_Fax         varchar(20)   ,
Corp_PostCd      char(6)       NOT NULL,
Corp_PayOff      char(2)       NOT NULL,
ZZJG_Cd          char(2)       ,
FRZG_Cd          char(2)       ,
JJLX_Cd          char(2)       ,
LSGX_Cd          char(2)       ,
Org_Cd           char(2)       ,
Ministry_Cd      char(9)       ,
Bank_ID          char(4)       ,
HFBas_AccountNo  char(12)      ,
HFBas_Open_Date  smalldatetime ,
HFBas_Status     char(2)       ,
HFBas_O_Amt      decimal(11,2) NOT NULL Default 0,
HFBas_N_Amt      decimal(11,2) NOT NULL Default 0,
HFBas_Rate_C     decimal(5,2)  NOT NULL Default 0,
HFBas_Rate_I     decimal(5,2)  NOT NULL Default 0,
HFSup_AccountNo  char(12)      ,
HFSup_Open_Date  smalldatetime ,
HFSup_Status     char(2)       ,
HFSup_O_Amt      decimal(11,2) NOT NULL Default 0,
HFSup_N_Amt      decimal(11,2) NOT NULL Default 0,
HFSup_Rate_C     decimal(5,2)  NOT NULL Default 0,
HFSup_Rate_I     decimal(5,2)  NOT NULL Default 0,
Ind_Injury_Amt   decimal(11,2) NOT NULL Default 0,
Maternity_Amt    decimal(11,2) NOT NULL Default 0,
Corp_Status	     char(2)       ,
TimeStamp        datetime
CONSTRAINT [PK_TCompany] PRIMARY KEY CLUSTERED
(Corp_ID ASC)
);
GO